<?php
	
class Table_Agences extends Zend_Db_Table_Abstract
{
    protected $_name    = 'agence';
    protected $_primary = 'AGENCE_NUMERO';
	
	public function getAgenceMannequin ($id) {
			
			$req=$this->select()
			->setIntegrityCheck(false)
			->from(array('ag' =>'agence'), array('*'))
			->join(array('apa' => 'apouragence'), 'ag.agence_numero = apa.agence_numero', array('*'))
			->join(array('m' => 'mannequin'), 'm.vip_numero = apa.vip_numero', array('*'))
			->where('m.vip_numero = ?', $id);
			
			$resu=$this->fetchRow($req);
			return $resu;
	}
}